﻿<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta charset="utf-8">
<meta name="renderer" content="webkit|ie-comp|ie-stand">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />
<meta http-equiv="Cache-Control" content="no-siteapp" />
<!--[if lt IE 9]>
<script type="text/javascript" src="../js/html5shiv.js"></script>
<script type="text/javascript" src="../js/respond.min.js"></script>
<![endif]-->
<link rel="stylesheet" type="text/css" href="../static/h-ui/css/H-ui.min.css" />
<link rel="stylesheet" type="text/css" href="../static/h-ui.admin/css/H-ui.admin.css" />
<link rel="stylesheet" type="text/css" href="../js/Hui-iconfont/1.0.8/iconfont.css" />
<link rel="stylesheet" type="text/css" href="../static/h-ui.admin/skin/default/skin.css" id="skin" />
<link rel="stylesheet" type="text/css" href="../static/h-ui.admin/css/style.css" />
<!--[if IE 6]>
<script type="text/javascript" src="../js/DD_belatedPNG_0.0.8a-min.js" ></script>
<script>DD_belatedPNG.fix('*');</script>
<![endif]-->
<title>用户管理</title>
</head>
<body>
<nav class="breadcrumb"><i class="Hui-iconfont">&#xe67f;</i> 首页 <span class="c-gray en">&gt;</span> 报表中心 <span class="c-gray en">&gt;</span> 部门调动人员信息 <a class="btn btn-success radius r" style="line-height:1.6em;margin-top:3px" href="javascript:location.replace(location.href);" title="刷新" ><i class="Hui-iconfont">&#xe68f;</i></a></nav>
<div class="page-container">
	<div class="text-c">
		<h1 style="padding-top: 0px">部门调动员工信息</h1>
	</div>
	<span>${startmsg.defaultMessage }</span><br/>
	<span>${endmsg.defaultMessage }</span><br/>
	<form id="dptTfUsers" action=""  method="post">
		<div class="text-c"> 部门调动日期范围：
			<input name="start" type="text" onfocus="WdatePicker({ maxDate:'#F{$dp.$D(\'datemax\')||\'%y-%M-%d\'}' })" id="datemin" class="input-text Wdate" style="width:120px;">
			-
			<input name="end" type="text" onfocus="WdatePicker({ minDate:'#F{$dp.$D(\'datemin\')}',maxDate:'%y-%M-%d' })" id="datemax" class="input-text Wdate" style="width:120px;">
			<button onClick="search()" type="button" class="btn btn-success radius" id="" name=""><i class="Hui-iconfont">&#xe665;</i> 搜索</button>
			<button onClick="exportExcel('tableExcel')" type="button" class="btn btn-success radius"> 生成报表</button>
		</div>
	</form>
	<div class="mt-20">
		<table id="tableExcel" class="table table-border table-bordered table-hover table-bg">
			<thead>
			<tr class="text-c">
				<th width="80">序号</th>
				<th width="200">原部门名称</th>
				<th width="200">新部门名称</th>
				<th width="80">姓名</th>
				<th width="80">性别</th>
				<th width="130">调动日期</th>
				<th width="180">调动原因</th>
			</tr>
			</thead>
			<tbody>
			<c:if test="${users==null }">
   				<tr><td colspan="5"><font color="red">没有符合条件的数据</font></td></tr>
   			</c:if>
   			<c:if test="${users!=null }">
   				<c:forEach items="${users }" var="user">
				<tr class="text-c">
					<td>${user.user_id}</td>
					<td>${user.dpt_original}</td>
					<td>${user.dpt_transfer}</td>
					<td>${user.user_name}</td>
					<td>${user.user_sex}</td>
					<td>${user.tf_date}</td>
					<td>${user.tf_reason}</td>
				</tr>
				</c:forEach>
			</c:if>
			</tbody>
		</table>
	</div>
</div>
<!--_footer 作为公共模版分离出去-->
<script type="text/javascript" src="../js/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript" src="../js/layer/2.4/layer.js"></script>
<script type="text/javascript" src="../static/h-ui/js/H-ui.min.js"></script>
<script type="text/javascript" src="../static/h-ui.admin/js/H-ui.admin.js"></script> <!--/_footer 作为公共模版分离出去-->

<!--请在下方写此页面业务相关的脚本-->
<script type="text/javascript" src="../js/My97DatePicker/4.8/WdatePicker.js"></script>
<script type="text/javascript" src="../js/datatables/1.10.0/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="../js/laypage/1.2/laypage.js"></script>
<script language="JavaScript" type="text/javascript"> 
var idTmr; 
//获取当前浏览器类型 
function getExplorer() { 
	var explorer = window.navigator.userAgent ; 
	//ie 
	if (explorer.indexOf("MSIE") >= 0) { 
		return 'ie'; 
	} 
	//firefox 
	else if (explorer.indexOf("Firefox") >= 0) { 
		return 'Firefox'; 
	} 
	//Chrome 
	else if(explorer.indexOf("Chrome") >= 0){ 
		return 'Chrome'; 
	} 
	//Opera 
	else if(explorer.indexOf("Opera") >= 0){ 
		return 'Opera'; 
	} 
	//Safari 
	else if(explorer.indexOf("Safari") >= 0){ 
		return 'Safari'; 
	} 
}
    
//获取到类型需要判断当前浏览器需要调用的方法，目前项目中火狐，谷歌，360没有问题 
//win10自带的IE无法导出 
function exportExcel(tableid) { 
	if(getExplorer()=='ie') 
	{ 
		var curTbl = document.getElementById(tableid); 
		var oXL = new ActiveXObject("Excel.Application"); 
	    var oWB = oXL.Workbooks.Add(); 
	    var xlsheet = oWB.Worksheets(1); 
	    var sel = document.body.createTextRange(); 
	    sel.moveToElementText(curTbl); 
	    sel.select(); 
	    sel.execCommand("Copy"); 
	    xlsheet.Paste(); 
	    oXL.Visible = true; 
  
		try { 
			var fname = oXL.Application.GetSaveAsFilename("Excel.xls", "Excel Spreadsheets (*.xls), *.xls"); 
		} catch (e) { 
			print("Nested catch caught " + e); 
		} finally { 
			oWB.SaveAs(fname); 
			oWB.Close(savechanges = false); 
			oXL.Quit(); 
			oXL = null; 
			idTmr = window.setInterval("Cleanup();", 1); 
		} 
  
	} 
	else 
	{ 
		tableToExcel(tableid) 
	} 
  } 
function Cleanup(){ 
	window.clearInterval(idTmr); 
	CollectGarbage(); 
} 
    
//判断浏览器后调用的方法，把table的id传入即可 
var tableToExcel = (function() { 
	var uri = 'data:application/vnd.ms-excel;base64,', 
	template = '<html><head><meta charset="UTF-8"></head><body><table>{table}</table></body></html>', 
	base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }, 
	format = function(s, c) { 
	return s.replace(/{(\w+)}/g, 
	function(m, p) { return c[p]; }) } 
	return function(table, name) { 
	if (!table.nodeType) table = document.getElementById(table) 
	var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML} 
	window.location.href = uri + base64(format(template, ctx)) 
	} 
})() 
  
</script> 
<script type="text/javascript">
$(function(){
	$('.table-sort').dataTable({
		"aaSorting": [[ 1, "desc" ]],//默认第几个排序
		"bStateSave": true,//状态保存
		"aoColumnDefs": [
		  //{"bVisible": false, "aTargets": [ 3 ]} //控制列的隐藏显示
		  {"orderable":false,"aTargets":[0,8,9]}// 制定列不参与排序
		]
	});
	
});
/* 搜索按钮提交表单 */
function  search()
{
	$("#dptTfUsers").removeAttr('action');
	$("#dptTfUsers").attr('action','${pageContext.request.contextPath }/paper/getDptTfUsers');
	$("#dptTfUsers").submit();
}
/*用户-添加*/
function member_add(title,url,w,h){
	layer_show(title,url,w,h);
}
/*用户-查看*/
function member_show(title,url,id,w,h){
	layer_show(title,url,w,h);
}
/*用户-停用*/
function member_stop(obj,id){
	layer.confirm('确认要停用吗？',function(index){
		$.ajax({
			type: 'POST',
			url: '',
			dataType: 'json',
			success: function(data){
				$(obj).parents("tr").find(".td-manage").prepend('<a style="text-decoration:none" onClick="member_start(this,id)" href="javascript:;" title="启用"><i class="Hui-iconfont">&#xe6e1;</i></a>');
				$(obj).parents("tr").find(".td-status").html('<span class="label label-defaunt radius">已停用</span>');
				$(obj).remove();
				layer.msg('已停用!',{icon: 5,time:1000});
			},
			error:function(data) {
				console.log(data.msg);
			},
		});		
	});
}

/*用户-启用*/
function member_start(obj,id){
	layer.confirm('确认要启用吗？',function(index){
		$.ajax({
			type: 'POST',
			url: '',
			dataType: 'json',
			success: function(data){
				$(obj).parents("tr").find(".td-manage").prepend('<a style="text-decoration:none" onClick="member_stop(this,id)" href="javascript:;" title="停用"><i class="Hui-iconfont">&#xe631;</i></a>');
				$(obj).parents("tr").find(".td-status").html('<span class="label label-success radius">已启用</span>');
				$(obj).remove();
				layer.msg('已启用!',{icon: 6,time:1000});
			},
			error:function(data) {
				console.log(data.msg);
			},
		});
	});
}
/*用户-编辑*/
function member_edit(title,url,id,w,h){
	layer_show(title,url,w,h);
}
/*密码-修改*/
function change_password(title,url,id,w,h){
	layer_show(title,url,w,h);	
}
/*用户-删除*/
function member_del(obj,id){
	layer.confirm('确认要删除吗？',function(index){
		$.ajax({
			type: 'POST',
			url: '',
			dataType: 'json',
			success: function(data){
				$(obj).parents("tr").remove();
				layer.msg('已删除!',{icon:1,time:1000});
			},
			error:function(data) {
				console.log(data.msg);
			},
		});		
	});
}
</script> 
</body>
</html>